﻿CREATE TYPE [flcr].[SERVICE_DEVICE_XREF_UDT] AS  TABLE (
    [SERVICE_DEVICE_XREF_ID] INT           NULL,
    [AUDIT_USER]             VARCHAR (100) NULL,
    [AUDIT_DTTM]             DATETIME      NULL,
    [AUDIT_DTTM_TZ]          INT           NULL,
    [AUDIT_MOD_USER]         VARCHAR (100) NULL,
    [AUDIT_MOD_DTTM]         DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ]      INT           NULL,
    [WRKFL_ITEM_ID]          INT           NULL,
    [WRKFL_STATUS_ID]        INT           NULL,
    [ACTIVE_FLG]             BIT           NULL,
    [ENV_ID]                 INT           NULL,
    [DEVICE_ID]              INT           NULL,
    [SERVICE_ID]             INT           NULL,
    [SERVICE_TYPE]           INT           NULL,
    [RESOURCE_ID]            INT           NULL,
    [SLA_ID]                 INT           NULL,
    [PARENT_ID]              INT           NULL);

